How to: Find duplicate records in a table using a query wizard.
Solution:
Click the 'Queries' tab in the Database window, click 'New', and select 'Find Duplicates Query Wizard' from the list box.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Click 'New'. (The New Query dialog box appears.)
4) Select 'Find Duplicates Query Wizard' from the 'New Query' list box.
5) Click 'OK'. (The next step of the wizard appears.)
6) Select the 'Tables' radio button.
7) Select the table to find duplicates in the list.
8) Click 'Next'. (The next step of the wizard appears.)
9) Select the first field possibly containing duplicate data from the 'Available Fields' list box.
10) Click '>' to move the selected field to the 'Duplicate-Value Field' list box.
11) Repeat steps 9) and 10) for each additional field possibly containing duplicate data.
12) Click 'Next'. (The next step of the wizard appears.)
13) Select the desired field in the 'Available Fields' list box to also appear with the list box containing duplicate data.
14) Click '>' toadd the selected field to the 'Additional query fields' list box.
15) Repeat steps 13) and 14) for each additional field to be added.
NOTE: Click '>' toadd all remaining fields to the 'Additional query fields' list box at one time.
16) Click 'Next'. (The next step of the wizard appears.)
17) Type the name for the new query in the 'What do you want to name your query?' box.
18) Click 'Finish'. (The final results appear on the screen.)
19) Select the 'File' menu and select 'Close' to close the query.
